package com.tianyi.sfzy1.mapper;

import com.tianyi.sfzy1.domain.Psychologicalquestion;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
* @author Lenovo
* @description 针对表【psychologicalquestion(心理答疑问题表)】的数据库操作Mapper
* @createDate 2025-01-02 11:46:53
* @Entity com.tianyi.sfzy1.domain.Psychologicalquestion
*/
public interface PsychologicalquestionMapper {

    int deleteByPrimaryKey(Long id);

    int insert(Psychologicalquestion record);

    int insertSelective(Psychologicalquestion record);

    Psychologicalquestion selectByPrimaryKey(Long id);
    List<Psychologicalquestion> selectAll();

    int updateByPrimaryKeySelective(Psychologicalquestion record);

    int updateByPrimaryKey(Psychologicalquestion record);
    int deleteArr(List<Integer> ids);//批量删除
//    模糊查询
    List<Psychologicalquestion> selectByExample(@Param("record") Psychologicalquestion record);
//    返回全部并带有用户姓名
    List<Psychologicalquestion> searchAllByMember(@Param("record") Psychologicalquestion record);


//       通过问题名或者问题内容或者关联会员表的会员用户名查询问题信息-->
//    孟迪
    List<Psychologicalquestion> searchAllByMember1(@Param("questionTitle") String questionTitle, @Param("questionContent") String questionContent, @Param("memberName") String memberName);

}
